Work in progress: performance regression tracking

Note:

Solution

data.table

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 3.3 3.2 3% 3.2 7% 3.4 -3%
2 4.3 4.5 -27% 4.4 -4% 4.6 -3%
3 5.9 5.7 2% 5.3 6% 4.9 4%
4 6.1 5.7 3% 6.0 2% 5.8 -4%
5 5.7 5.7 6% 7.2 -8% 5.1 -2%
6 46.4 52.8 -1% 51.1 1%
7 37.0 38.0 0% 39.7 -1%
8 82.1 86.4 -3% 88.1 -2%
9 16.7 15.9 7% 16.7 8% 25.0 -14%
10 67.9 75.0 -2% 72.2 0% 66.4 0%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 0.6 0.7 0% 0.6 7%
1e8 6.2 6.4 -2% 6.2 0%
1e9 75.8 80.8 -1% 81.4 -3%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 27.6 29.3 -1% 29.4 1%
1e1 95.6 93.2 1% 92.1 0%
2e0 61.1 60.4 0% 61.1 0%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 27.6 29.3 -1% 29.4 1%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 27.6 29.3 -1% 29.4 1%
1 23.0 23.4 4%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.1 0.1 8% 0.1 16% 0.1 -7%
1 1e8 0.9 0.9 -1% 0.9 3% 1.0 -2%
1 1e9 8.9 8.7 2% 8.7 3% 9.0 0%
2 1e7 0.1 0.6 -83% 0.1 -12% 0.1 0%
2 1e8 1.0 1.0 0% 1.0 0% 1.0 -3%
2 1e9 11.9 11.9 0% 12.0 0% 12.7 -5%
3 1e7 0.1 0.1 7% 0.1 10% 0.1 0%
3 1e8 1.3 1.3 -2% 1.3 0% 1.4 -7%
3 1e9 16.2 15.7 3% 14.6 11% 13.2 23%
4 1e7 0.2 0.2 10% 0.2 14% 0.3 -17%
4 1e8 1.5 1.6 -6% 1.7 -10% 1.5 0%
4 1e9 16.6 15.3 8% 16.0 3% 15.7 5%
5 1e7 0.2 0.1 21% 0.2 13% 0.2 -11%
5 1e8 1.5 1.5 -1% 1.7 -16% 1.6 -9%
5 1e9 15.3 15.6 -1% 19.7 -22% 13.6 13%
6 1e7 1.1 1.1 8% 1.0 14%
6 1e8 11.7 11.5 1% 11.7 0%
6 1e9 126.4 145.7 -13% 140.5 -10%
7 1e7 0.6 0.6 2% 0.6 3%
7 1e8 7.2 7.3 -2% 7.2 0%
7 1e9 103.2 105.9 -2% 111.4 -7%
8 1e7 1.5 1.4 1% 1.4 0%
8 1e8 16.3 17.7 -7% 16.5 -1%
8 1e9 228.6 240.0 -4% 246.5 -7%
9 1e7 0.9 0.8 19% 0.8 15% 0.7 24%
9 1e8 3.7 3.8 -2% 3.3 11% 5.7 -33%
9 1e9 45.6 43.1 5% 45.9 0% 68.6 -33%
10 1e7 1.6 1.5 5% 1.6 1% 1.7 -4%
10 1e8 17.3 17.6 -1% 16.8 2% 16.4 5%
10 1e9 184.9 205.8 -10% 198.2 -6% 181.2 2%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 3.3 3.2 3% 3.2 7% 3.4 -3%
1 1e1 4.3 4.0 12% 4.3 4% 4.2 8%
1 2e0 5.2 4.9 3% 4.9 0% 4.8 3%
2 1e2 4.3 4.5 -27% 4.4 -4% 4.6 -3%
2 1e1 5.5 5.2 0% 6.3 -5% 5.8 -11%
2 2e0 6.3 6.0 10% 5.9 6% 5.5 20%
3 1e2 5.9 5.7 2% 5.3 6% 4.9 4%
3 1e1 11.1 11.0 -1% 10.8 -1% 10.5 -17%
3 2e0 214.4 212.8 0% 215.6 -5%
4 1e2 6.1 5.7 3% 6.0 2% 5.8 -4%
4 1e1 8.3 7.9 3% 7.6 8% 7.7 6%
4 2e0 1.4 1.3 2% 1.3 -2% 1.3 0%
5 1e2 5.7 5.7 6% 7.2 -8% 5.1 -2%
5 1e1 11.7 12.3 -2% 12.3 -4% 12.0 -15%
5 2e0 3.8 3.8 -7% 3.6 -2% 3.7 -12%
6 1e2 46.4 52.8 -1% 51.1 1%
6 1e1 37.5 36.3 0% 39.1 -3%
6 2e0 2.7 2.9 -2% 3.0 -8%
7 1e2 37.0 38.0 0% 39.7 -1%
7 1e1 161.6 154.5 1% 151.6 2%
7 2e0 64.6 65.6 -1% 65.9 0%
8 1e2 82.1 86.4 -3% 88.1 -2%
8 1e1 583.6 567.5 0% 556.0 1%
8 2e0 279.4 273.5 0% 278.2 0%
9 1e2 16.7 15.9 7% 16.7 8% 25.0 -14%
9 1e1 12.2 12.0 0% 12.0 -1% 18.5 -29%
9 2e0 1.5 1.5 -5% 1.5 6% 1.8 -9%
10 1e2 67.9 75.0 -2% 72.2 0% 66.4 0%
10 1e1 120.7 120.9 2% 120.7 0% 120.6 3%
10 2e0 10.0 10.2 -4% 9.8 2% 11.8 -34%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 0.6 0.7 0% 0.6 7%
1e2 1e8 6.2 6.4 -2% 6.2 0%
1e2 1e9 75.8 80.8 -1% 81.4 -3%
1e1 1e7 1.8 1.8 4% 1.8 0%
1e1 1e8 21.3 22.3 -3% 21.4 -1%
1e1 1e9 263.8 255.4 3% 253.1 0%
2e0 1e7 8.0 8.2 -2% 7.9 -2%
2e0 1e8 68.2 67.0 0% 68.3 0%
2e0 1e9 214.5 212.4 5% 214.4 5%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 3.3 3.2 3% 3.2 7% 3.4 -3%
1e2 2 4.3 4.5 -27% 4.4 -4% 4.6 -3%
1e2 3 5.9 5.7 2% 5.3 6% 4.9 4%
1e2 4 6.1 5.7 3% 6.0 2% 5.8 -4%
1e2 5 5.7 5.7 6% 7.2 -8% 5.1 -2%
1e2 6 46.4 52.8 -1% 51.1 1%
1e2 7 37.0 38.0 0% 39.7 -1%
1e2 8 82.1 86.4 -3% 88.1 -2%
1e2 9 16.7 15.9 7% 16.7 8% 25.0 -14%
1e2 10 67.9 75.0 -2% 72.2 0% 66.4 0%
1e1 1 4.3 4.0 12% 4.3 4% 4.2 8%
1e1 2 5.5 5.2 0% 6.3 -5% 5.8 -11%
1e1 3 11.1 11.0 -1% 10.8 -1% 10.5 -17%
1e1 4 8.3 7.9 3% 7.6 8% 7.7 6%
1e1 5 11.7 12.3 -2% 12.3 -4% 12.0 -15%
1e1 6 37.5 36.3 0% 39.1 -3%
1e1 7 161.6 154.5 1% 151.6 2%
1e1 8 583.6 567.5 0% 556.0 1%
1e1 9 12.2 12.0 0% 12.0 -1% 18.5 -29%
1e1 10 120.7 120.9 2% 120.7 0% 120.6 3%
2e0 1 5.2 4.9 3% 4.9 0% 4.8 3%
2e0 2 6.3 6.0 10% 5.9 6% 5.5 20%
2e0 3 214.4 212.8 0% 215.6 -5%
2e0 4 1.4 1.3 2% 1.3 -2% 1.3 0%
2e0 5 3.8 3.8 -7% 3.6 -2% 3.7 -12%
2e0 6 2.7 2.9 -2% 3.0 -8%
2e0 7 64.6 65.6 -1% 65.9 0%
2e0 8 279.4 273.5 0% 278.2 0%
2e0 9 1.5 1.5 -5% 1.5 6% 1.8 -9%
2e0 10 10.0 10.2 -4% 9.8 2% 11.8 -34%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.6 0.7 0% 0.6 7%
0 1e8 6.2 6.4 -2% 6.2 0%
0 1e9 75.8 80.8 -1% 81.4 -3%
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.6 0.7 0% 0.6 7%
0 1e8 6.2 6.4 -2% 6.2 0%
0 1e9 75.8 80.8 -1% 81.4 -3%
1 1e7 0.5 0.5 -1% 0.5 0%
1 1e8 5.1 5.0 4% 5.3 0%
1 1e9 63.4 64.7 12%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 2.4 2.5 -11% 2.5 -4%
2 2.0 2.2 -4% 2.0 0%
3 4.3 4.3 0% 4.2 2%
4 2.0 2.1 -2% 2.0 2%
5 13.8 13.9 7% 13.4 10%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 0.9 0.9 0% 0.8 4%
1e8 8.9 9.2 -4% 8.8 0%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 4.9 5.0 -2% 4.8 2%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 4.9 5.0 -2% 4.8 2%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.3 0.4 -21% 0.3 -6%
1 1e8 4.6 4.7 -2% 4.7 -2%
2 1e7 0.4 0.4 1% 0.4 0%
2 1e8 3.7 4.1 -10% 3.6 0%
3 1e7 0.7 0.7 2% 0.7 2%
3 1e8 7.8 8.0 -2% 7.7 1%
4 1e7 0.3 0.3 2% 0.3 4%
4 1e8 3.6 4.0 -7% 3.7 0%
5 1e7 2.9 2.5 17% 2.4 20%
5 1e8 24.6 25.4 -3% 24.4 1%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.9 0.9 0% 0.8 4%
0 1e8 8.9 9.2 -4% 8.8 0%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.9 0.9 0% 0.8 4%
0 1e8 8.9 9.2 -4% 8.8 0%

dplyr

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 8.3
2 24.0
3 88.0
4 32.5
5 192.9
6 7.2 7.3 1% 7.4 0%
7 13.2 13.2 2% 13.2 2%
8 28.1 28.4 0% 28.7 -1%
9 50.4
10 897.2 1010.8 -7% 1045.7 -8%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 17.1 17.6 -3% 17.4 0%
1e8 181.8 204.3 -3% 211.4 -3%
1e9 183.4
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2
1e1
2e0 142.2 146.0 -2% 144.2 0%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
1
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.3 0.4 -18% 0.3 -1% 0.3 26%
1 1e8 3.3 3.5 -6% 3.4 -2% 2.2 51%
1 1e9 22.6
2 1e7 0.8 0.9 -5% 0.9 -5% 0.5 65%
2 1e8 9.1 9.3 -2% 9.4 -3% 6.3 44%
2 1e9 65.1
3 1e7 1.8 1.9 -3% 1.7 2% 0.7 138%
3 1e8 30.3 30.6 0% 30.5 0% 16.6 82%
3 1e9 246.5
4 1e7 0.5 0.6 -7% 0.5 -2% 0.6 -7%
4 1e8 6.0 6.6 -9% 6.2 -4% 8.2 -27%
4 1e9 88.7
5 1e7 1.5 1.5 -2% 1.5 0% 1.5 -2%
5 1e8 30.9 31.6 -2% 30.7 0% 38.4 -19%
5 1e9 538.8
6 1e7 1.6 1.6 4% 1.6 4%
6 1e8 12.8 13.0 -2% 13.2 -3%
7 1e7 1.1 1.1 4% 1.1 5%
7 1e8 25.2 25.3 0% 25.4 0%
8 1e7 3.8 3.9 0% 3.9 -1%
8 1e8 52.4 53.0 -1% 53.4 -1%
9 1e7 1.3 1.3 0% 1.4 -6% 1.3 -2%
9 1e8 11.5 11.4 1% 11.6 0% 10.8 7%
9 1e9 139.0
10 1e7 158.3 163.1 -2% 161.1 -1%
10 1e8 1636.1 1858.5 -11% 1930.4 -15%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 8.3
1 1e1 10.3 10.5 2% 10.4 -1% 6.3 100%
1 2e0 7.9 8.8 -4% 8.4 -3% 4.5 92%
2 1e2 24.0
2 1e1 11.0
2 2e0 12.7 12.2 0% 12.4 0% 7.6 78%
3 1e2 88.0
3 1e1 173.4
3 2e0 272.4 282.2 -3% 274.0 -1% 40.3 577%
4 1e2 32.5
4 1e1 19.2
4 2e0 1.6 1.8 0% 1.4 14% 1.6 5%
5 1e2 192.9
5 1e1 472.9
5 2e0 293.7 302.8 -3% 300.0 -1% 85.7 223%
6 1e2 7.2 7.3 1% 7.4 0%
6 1e1 3.9 3.8 3% 4.1 -3%
6 2e0 3.2 3.5 -6% 3.4 0%
7 1e2 13.2 13.2 2% 13.2 2%
7 1e1 51.6 49.6 1% 50.8 1%
7 2e0 188.7 194.4 -2% 187.8 2%
8 1e2 28.1 28.4 0% 28.7 -1%
8 1e1 148.2 161.5 -5% 166.5 -6%
8 2e0 608.5 618.1 -3% 620.0 -2%
9 1e2 50.4
9 1e1 3.7 3.7 5% 3.8 2% 3.2 21%
9 2e0 2.7 2.9 -3% 2.5 4% 2.0 28%
10 1e2 897.2 1010.8 -7% 1045.7 -8%
10 1e1 1098.2 1008.2 3% 1087.0 0%
10 2e0 181.3 191.0 -5% 187.8 -3%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 17.1 17.6 -3% 17.4 0%
1e2 1e8 181.8 204.3 -3% 211.4 -3%
1e2 1e9 183.4
1e1 1e7 22.2 22.8 0% 22.7 -1%
1e1 1e8 271.1 253.0 4% 271.0 0%
1e1 1e9 381.7
2e0 1e7 39.9 41.7 -2% 40.9 1%
2e0 1e8 281.2 288.0 -3% 284.9 0%
2e0 1e9 27.7 28.3 -3% 28.0 -1% 16.4 70%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 8.3
1e2 2 24.0
1e2 3 88.0
1e2 4 32.5
1e2 5 192.9
1e2 6 7.2 7.3 1% 7.4 0%
1e2 7 13.2 13.2 2% 13.2 2%
1e2 8 28.1 28.4 0% 28.7 -1%
1e2 9 50.4
1e2 10 897.2 1010.8 -7% 1045.7 -8%
1e1 1 10.3 10.5 2% 10.4 -1% 6.3 100%
1e1 2 11.0
1e1 3 173.4
1e1 4 19.2
1e1 5 472.9
1e1 6 3.9 3.8 3% 4.1 -3%
1e1 7 51.6 49.6 1% 50.8 1%
1e1 8 148.2 161.5 -5% 166.5 -6%
1e1 9 3.7 3.7 5% 3.8 2% 3.2 21%
1e1 10 1098.2 1008.2 3% 1087.0 0%
2e0 1 7.9 8.8 -4% 8.4 -3% 4.5 92%
2e0 2 12.7 12.2 0% 12.4 0% 7.6 78%
2e0 3 272.4 282.2 -3% 274.0 -1% 40.3 577%
2e0 4 1.6 1.8 0% 1.4 14% 1.6 5%
2e0 5 293.7 302.8 -3% 300.0 -1% 85.7 223%
2e0 6 3.2 3.5 -6% 3.4 0%
2e0 7 188.7 194.4 -2% 187.8 2%
2e0 8 608.5 618.1 -3% 620.0 -2%
2e0 9 2.7 2.9 -3% 2.5 4% 2.0 28%
2e0 10 181.3 191.0 -5% 187.8 -3%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 17.1 17.6 -3% 17.4 0%
0 1e8 181.8 204.3 -3% 211.4 -3%
0 1e9 183.4
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 17.1 17.6 -3% 17.4 0%
0 1e8 181.8 204.3 -3% 211.4 -3%
0 1e9 183.4
1 1e7 15.0 15.0 -3% 15.7 -3%
1 1e8 167.2 169.6 0% 177.3 -3%
1 1e9 149.2

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 9.0 9.0 1% 9.1 1%
2 8.5 8.3 -1% 8.2 4%
3 10.1 10.0 0% 10.0 0%
4 8.8 8.6 3% 8.8 0%
5 93.6 92.5 1% 93.6 0%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 3.7 3.6 0% 3.6 1%
1e8 48.4 47.7 1% 48.3 0%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 26.0 25.7 1% 25.9 1%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 26.0 25.7 1% 25.9 1%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 1.6 1.5 1% 1.5 3%
1 1e8 16.5 16.4 0% 16.7 0%
2 1e7 1.3 1.4 -7% 1.2 4%
2 1e8 15.8 15.1 4% 15.2 3%
3 1e7 1.5 1.5 0% 1.5 0%
3 1e8 18.6 18.4 0% 18.5 0%
4 1e7 1.3 1.3 5% 1.3 0%
4 1e8 16.4 16.0 2% 16.2 1%
5 1e7 12.6 12.4 1% 12.4 1%
5 1e8 174.7 172.6 1% 174.9 0%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 3.7 3.6 0% 3.6 1%
0 1e8 48.4 47.7 1% 48.3 0%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 3.7 3.6 0% 3.6 1%
0 1e8 48.4 47.7 1% 48.3 0%

pandas

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 2.4 2.4 -4% 2.5 1% 1.4 62%
2 6.5 6.2 0% 6.6 -3% 3.7 71%
3 7.1 7.0 2% 7.4 0% 3.7 91%
4 3.0 2.9 1% 3.1 2% 3.2 -1%
5 7.9 7.7 0% 7.2 6% 7.1 6%
6 8.8 8.6 -3% 8.7 0%
7 6.4 6.5 -3% 6.6 -1%
8 25.8 25.6 0% 26.1 0%
9 27.2 27.2 0% 30.3 -14% 29.0 -10%
10 122.5 122.6 0% 125.9 -3%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 3.2 3.3 -3% 3.6 0%
1e8 40.3 40.1 1% 41.3 -2%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 21.8 21.7 0% 22.4 -1%
1e1 20.9 20.7 0% 20.8 0%
2e0 34.7 34.7 0% 35.0 1%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 21.8 21.7 0% 22.4 -1%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 21.8 21.7 0% 22.4 -1%
1 16.1 15.7 3% 16.3 0%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.5 0.5 -8% 0.4 8% 0.3 46%
1 1e8 4.3 4.3 -1% 4.6 -6% 2.4 78%
2 1e7 1.1 1.2 -7% 1.2 -4% 0.7 65%
2 1e8 11.8 11.2 5% 12.1 -1% 6.7 77%
3 1e7 1.0 1.0 3% 1.0 2% 0.5 87%
3 1e8 13.3 13.0 1% 13.8 -4% 6.8 94%
4 1e7 0.6 0.6 0% 0.5 10% 0.5 5%
4 1e8 5.4 5.2 4% 5.7 -5% 5.9 -8%
5 1e7 0.9 0.9 -1% 0.9 3% 0.9 -1%
5 1e8 14.9 14.5 2% 13.5 10% 13.2 13%
6 1e7 1.5 1.7 -9% 1.5 1%
6 1e8 16.0 15.6 2% 15.9 0%
7 1e7 0.9 0.9 -5% 0.9 1%
7 1e8 11.9 12.1 -2% 12.4 -4%
8 1e7 3.5 3.6 -1% 3.6 0%
8 1e8 48.0 47.5 1% 48.6 -1%
9 1e7 10.5 10.7 -1% 13.9 -24% 12.8 -17%
9 1e8 43.9 43.7 0% 46.6 -5% 45.1 -2%
10 1e7 11.7 11.7 0% 12.3 -5%
10 1e8 233.3 233.4 0% 239.4 -2%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 2.4 2.4 -4% 2.5 1% 1.4 62%
1 1e1 2.4 2.3 0% 2.3 0% 1.2 103%
1 2e0 2.0 2.0 0% 2.0 0% 1.2 77%
2 1e2 6.5 6.2 0% 6.6 -3% 3.7 71%
2 1e1 5.6 5.6 -2% 5.9 -4% 3.0 87%
2 2e0 5.0 4.8 2% 4.7 4% 3.0 62%
3 1e2 7.1 7.0 2% 7.4 0% 3.7 91%
3 1e1 20.4 19.7 2% 19.8 3% 8.6 156%
3 2e0 56.7 56.8 1% 56.8 0% 14.6 292%
4 1e2 3.0 2.9 1% 3.1 2% 3.2 -1%
4 1e1 2.9 2.9 -1% 2.9 -2% 3.3 -10%
4 2e0 2.9 2.9 0% 2.9 2% 3.4 -10%
5 1e2 7.9 7.7 0% 7.2 6% 7.1 6%
5 1e1 15.8 15.7 3% 15.4 5% 16.0 3%
5 2e0 32.0 31.9 1% 32.2 0% 32.5 0%
6 1e2 8.8 8.6 -3% 8.7 0%
6 1e1 6.3 6.2 -1% 6.2 0%
6 2e0 5.8 5.8 1% 5.5 6%
7 1e2 6.4 6.5 -3% 6.6 -1%
7 1e1 18.6 18.6 -1% 19.5 -5%
7 2e0 55.2 55.3 0% 59.9 -6%
8 1e2 25.8 25.6 0% 26.1 0%
8 1e1 32.7 32.8 -2% 32.6 0%
8 2e0 48.8 48.9 0% 48.4 1%
9 1e2 27.2 27.2 0% 30.3 -14% 29.0 -10%
9 1e1 17.0 17.0 0% 16.6 -1% 15.4 6%
9 2e0 12.9 13.2 -1% 11.9 8% 11.6 11%
10 1e2 122.5 122.6 0% 125.9 -3%
10 1e1 87.6 86.5 1% 86.7 0%
10 2e0 125.5 125.5 1% 125.3 0%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 3.2 3.3 -3% 3.6 0%
1e2 1e8 40.3 40.1 1% 41.3 -2%
1e1 1e7 2.9 2.9 -1% 3.0 -1%
1e1 1e8 38.9 38.5 0% 38.6 0%
2e0 1e7 5.2 5.1 0% 5.2 2%
2e0 1e8 64.1 64.3 0% 64.7 1%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 2.4 2.4 -4% 2.5 1% 1.4 62%
1e2 2 6.5 6.2 0% 6.6 -3% 3.7 71%
1e2 3 7.1 7.0 2% 7.4 0% 3.7 91%
1e2 4 3.0 2.9 1% 3.1 2% 3.2 -1%
1e2 5 7.9 7.7 0% 7.2 6% 7.1 6%
1e2 6 8.8 8.6 -3% 8.7 0%
1e2 7 6.4 6.5 -3% 6.6 -1%
1e2 8 25.8 25.6 0% 26.1 0%
1e2 9 27.2 27.2 0% 30.3 -14% 29.0 -10%
1e2 10 122.5 122.6 0% 125.9 -3%
1e1 1 2.4 2.3 0% 2.3 0% 1.2 103%
1e1 2 5.6 5.6 -2% 5.9 -4% 3.0 87%
1e1 3 20.4 19.7 2% 19.8 3% 8.6 156%
1e1 4 2.9 2.9 -1% 2.9 -2% 3.3 -10%
1e1 5 15.8 15.7 3% 15.4 5% 16.0 3%
1e1 6 6.3 6.2 -1% 6.2 0%
1e1 7 18.6 18.6 -1% 19.5 -5%
1e1 8 32.7 32.8 -2% 32.6 0%
1e1 9 17.0 17.0 0% 16.6 -1% 15.4 6%
1e1 10 87.6 86.5 1% 86.7 0%
2e0 1 2.0 2.0 0% 2.0 0% 1.2 77%
2e0 2 5.0 4.8 2% 4.7 4% 3.0 62%
2e0 3 56.7 56.8 1% 56.8 0% 14.6 292%
2e0 4 2.9 2.9 0% 2.9 2% 3.4 -10%
2e0 5 32.0 31.9 1% 32.2 0% 32.5 0%
2e0 6 5.8 5.8 1% 5.5 6%
2e0 7 55.2 55.3 0% 59.9 -6%
2e0 8 48.8 48.9 0% 48.4 1%
2e0 9 12.9 13.2 -1% 11.9 8% 11.6 11%
2e0 10 125.5 125.5 1% 125.3 0%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 3.2 3.3 -3% 3.6 0%
0 1e8 40.3 40.1 1% 41.3 -2%
Sortedness
by Sortedness (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 3.2 3.3 -3% 3.6 0%
0 1e8 40.3 40.1 1% 41.3 -2%
1 1e7 2.8 2.8 1% 3.2 -1%
1 1e8 29.3 28.6 4% 29.4 0%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 10.3 10.6 -1% 40.9 -70%
2 15.7 16.7 -5% 68.3 -76%
3 19.7 19.9 0% 37.4 -45%
4 29.2 30.1 -1% 59.4 -48%
5 62.4 63.2 -1% 197.9 -64%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 4.0 4.1 -1% 10.0 -57%
1e8 50.9 52.1 -3% 151.6 -64%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 27.5 28.1 -2% 80.8 -61%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 27.5 28.1 -2% 80.8 -61%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 1.6 1.6 0% 4.5 -65%
1 1e8 19.0 19.6 -3% 77.3 -75%
2 1e7 2.3 2.5 -5% 9.6 -75%
2 1e8 29.0 30.9 -6% 127.0 -77%
3 1e7 3.0 3.0 1% 5.4 -43%
3 1e8 36.3 36.9 -1% 69.5 -47%
4 1e7 4.3 4.3 0% 7.8 -45%
4 1e8 54.2 55.9 -3% 111.0 -51%
5 1e7 9.0 9.1 -1% 22.6 -60%
5 1e8 115.9 117.3 -1% 373.3 -68%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 4.0 4.1 -1% 10.0 -57%
0 1e8 50.9 52.1 -3% 151.6 -64%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 4.0 4.1 -1% 10.0 -57%
0 1e8 50.9 52.1 -3% 151.6 -64%

pydatatable

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 18.7 15.2 13% 16.1 6% 9.8 81%
2 24.6 25.9 -2% 23.5 1% 18.0 27%
3 51.5 52.7 -1% 52.0 -5% 49.3 3%
4 38.7 36.0 6% 37.3 5% 7.2 371%
5 9.6 9.3 0% 9.3 8% 8.4 0%
6 95.3 106.7 -10% 96.5 1%
7 54.1 52.7 3% 51.7 5%
8 103.3 116.6 -14% 98.3 6%
9 8.1 8.2 -4% 8.0 1%
10 338.5 356.8 -1% 330.3 8% 309.2 10%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 2.2 2.2 -4% 2.0 4%
1e8 25.8 27.4 0% 24.6 3%
1e9 194.8 204.4 0% 190.3 3%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 74.2 78.0 -1% 72.3 3%
1e1 74.2 76.4 3% 74.3 5%
2e0 122.8 126.2 0% 123.5 1%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 74.2 78.0 -1% 72.3 3%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 74.2 78.0 -1% 72.3 3%
1 56.1 61.6 -2% 55.0 1%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.4 0.4 2% 0.4 0% 0.2 80%
1 1e8 4.5 4.0 13% 4.4 1% 2.6 72%
1 1e9 51.1 41.2 23% 43.5 17% 26.7 91%
2 1e7 0.5 0.6 -7% 0.6 -3% 0.5 15%
2 1e8 7.0 6.6 6% 6.9 1% 5.5 29%
2 1e9 66.3 70.5 -6% 63.0 5% 48.1 37%
3 1e7 1.2 1.3 -3% 1.5 -15% 1.3 -2%
3 1e8 12.2 11.8 3% 12.1 0% 11.1 9%
3 1e9 141.1 145.0 -2% 142.4 0% 135.6 4%
4 1e7 1.0 0.9 11% 0.9 12% 0.3 251%
4 1e8 10.0 9.9 0% 9.9 1% 1.9 420%
4 1e9 105.2 97.3 8% 101.0 4% 19.3 444%
5 1e7 0.3 0.4 -15% 0.3 10% 0.5 -29%
5 1e8 3.8 3.4 10% 3.3 12% 3.4 10%
5 1e9 24.7 24.0 2% 24.3 1% 21.2 16%
6 1e7 1.4 1.5 -6% 1.4 4%
6 1e8 75.4 89.0 -15% 74.2 1%
6 1e9 209.1 229.6 -8% 213.9 -2%
7 1e7 1.2 1.1 7% 1.1 12%
7 1e8 11.9 12.0 0% 12.3 -2%
7 1e9 149.2 144.9 2% 141.6 5%
8 1e7 2.8 3.5 -18% 2.6 6%
8 1e8 29.3 33.6 -12% 27.3 7%
8 1e9 277.6 312.8 -11% 265.0 4%
9 1e7 0.2 0.3 -17% 0.2 0%
9 1e8 2.2 2.1 3% 2.1 3%
9 1e9 21.9 22.0 0% 21.7 1%
10 1e7 12.5 12.3 1% 11.0 13% 12.1 3%
10 1e8 101.6 101.2 0% 93.0 9% 85.6 18%
10 1e9 901.5 957.0 -5% 886.7 1% 830.0 8%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 18.7 15.2 13% 16.1 6% 9.8 81%
1 1e1 8.7 8.3 2% 8.8 -1% 4.4 81%
1 2e0 9.0 8.9 -2% 8.1 0% 4.3 77%
2 1e2 24.6 25.9 -2% 23.5 1% 18.0 27%
2 1e1 22.5 22.8 2% 21.8 -2% 9.8 100%
2 2e0 13.8 14.2 1% 13.3 2% 6.3 89%
3 1e2 51.5 52.7 -1% 52.0 -5% 49.3 3%
3 1e1 121.6 126.7 8% 121.8 9% 124.8 1%
3 2e0 325.5 335.7 0% 328.0 0% 243.5 43%
4 1e2 38.7 36.0 6% 37.3 5% 7.2 371%
4 1e1 14.3 12.7 7% 13.4 4% 3.4 279%
4 2e0 11.2 12.1 0% 12.1 0% 4.0 182%
5 1e2 9.6 9.3 0% 9.3 8% 8.4 0%
5 1e1 45.2 43.4 0% 43.9 4% 57.2 -22%
5 2e0 25.6 25.9 -6% 25.0 -1% 53.6 -58%
6 1e2 95.3 106.7 -10% 96.5 1%
6 1e1 29.6 29.5 -3% 29.2 2%
6 2e0 12.4 12.1 4% 11.9 3%
7 1e2 54.1 52.7 3% 51.7 5%
7 1e1 117.0 120.7 1% 115.2 2%
7 2e0 312.3 319.1 1% 312.8 1%
8 1e2 103.3 116.6 -14% 98.3 6%
8 1e1 43.7 42.3 8% 44.1 10%
8 2e0 27.0 27.4 -3% 27.3 2%
9 1e2 8.1 8.2 -4% 8.0 1%
9 1e1 10.3 12.2 8% 6.5 29%
9 2e0 8.3 8.5 3% 8.3 0%
10 1e2 338.5 356.8 -1% 330.3 8% 309.2 10%
10 1e1 329.3 345.3 0% 338.5 -1% 300.6 13%
10 2e0 482.8 498.5 1% 488.1 0% 286.3 77%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 2.2 2.2 -4% 2.0 4%
1e2 1e8 25.8 27.4 0% 24.6 3%
1e2 1e9 194.8 204.4 0% 190.3 3%
1e1 1e7 1.8 1.8 10% 1.9 2%
1e1 1e8 18.3 17.3 1% 17.1 6%
1e1 1e9 202.5 210.1 0% 204.0 7%
2e0 1e7 3.2 3.2 0% 3.2 0%
2e0 1e8 32.5 31.4 2% 32.1 2%
2e0 1e9 332.6 344.1 -2% 335.2 0%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 18.7 15.2 13% 16.1 6% 9.8 81%
1e2 2 24.6 25.9 -2% 23.5 1% 18.0 27%
1e2 3 51.5 52.7 -1% 52.0 -5% 49.3 3%
1e2 4 38.7 36.0 6% 37.3 5% 7.2 371%
1e2 5 9.6 9.3 0% 9.3 8% 8.4 0%
1e2 6 95.3 106.7 -10% 96.5 1%
1e2 7 54.1 52.7 3% 51.7 5%
1e2 8 103.3 116.6 -14% 98.3 6%
1e2 9 8.1 8.2 -4% 8.0 1%
1e2 10 338.5 356.8 -1% 330.3 8% 309.2 10%
1e1 1 8.7 8.3 2% 8.8 -1% 4.4 81%
1e1 2 22.5 22.8 2% 21.8 -2% 9.8 100%
1e1 3 121.6 126.7 8% 121.8 9% 124.8 1%
1e1 4 14.3 12.7 7% 13.4 4% 3.4 279%
1e1 5 45.2 43.4 0% 43.9 4% 57.2 -22%
1e1 6 29.6 29.5 -3% 29.2 2%
1e1 7 117.0 120.7 1% 115.2 2%
1e1 8 43.7 42.3 8% 44.1 10%
1e1 9 10.3 12.2 8% 6.5 29%
1e1 10 329.3 345.3 0% 338.5 -1% 300.6 13%
2e0 1 9.0 8.9 -2% 8.1 0% 4.3 77%
2e0 2 13.8 14.2 1% 13.3 2% 6.3 89%
2e0 3 325.5 335.7 0% 328.0 0% 243.5 43%
2e0 4 11.2 12.1 0% 12.1 0% 4.0 182%
2e0 5 25.6 25.9 -6% 25.0 -1% 53.6 -58%
2e0 6 12.4 12.1 4% 11.9 3%
2e0 7 312.3 319.1 1% 312.8 1%
2e0 8 27.0 27.4 -3% 27.3 2%
2e0 9 8.3 8.5 3% 8.3 0%
2e0 10 482.8 498.5 1% 488.1 0% 286.3 77%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.2 2.2 -4% 2.0 4%
0 1e8 25.8 27.4 0% 24.6 3%
0 1e9 194.8 204.4 0% 190.3 3%
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.2 2.2 -4% 2.0 4%
0 1e8 25.8 27.4 0% 24.6 3%
0 1e9 194.8 204.4 0% 190.3 3%
1 1e7 1.8 2.0 0% 1.7 5%
1 1e8 20.2 24.4 -5% 20.8 -1%
1 1e9 146.2 158.5 -2% 142.3 1%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 672.7 289.6 74% 390.9 96%
2 926.9 259.6 123% 495.0 78%
3 510.2 182.8 87% 348.6 70%
4 795.1 267.4 91% 455.9 74%
5 239.7 83.5 87% 141.8 41%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 9.2 25.6 -63% 5.2 93%
1e8 329.7 135.5 146% 208.9 56%
1e9 1874.9 589.9 221% 1071.1 73%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 656.7 226.1 93% 382.5 74%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 656.7 226.1 93% 382.5 74%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 10.0 25.7 -61% 3.8 161%
1 1e8 306.3 123.8 147% 200.1 53%
1 1e9 1701.8 719.1 136% 968.8 75%
2 1e7 10.7 33.7 -68% 5.9 80%
2 1e8 388.7 179.9 116% 236.5 64%
2 1e9 2381.2 565.1 321% 1242.5 91%
3 1e7 5.5 20.1 -72% 2.6 113%
3 1e8 181.7 76.5 137% 118.2 53%
3 1e9 1343.4 451.9 197% 925.0 45%
4 1e7 10.0 18.5 -46% 4.9 102%
4 1e8 302.3 160.3 88% 214.6 40%
4 1e9 2073.0 623.4 232% 1148.3 80%
5 1e7 9.7 30.1 -67% 8.7 11%
5 1e8 469.7 136.9 243% 274.9 70%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 9.2 25.6 -63% 5.2 93%
0 1e8 329.7 135.5 146% 208.9 56%
0 1e9 1874.9 589.9 221% 1071.1 73%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 9.2 25.6 -63% 5.2 93%
0 1e8 329.7 135.5 146% 208.9 56%
0 1e9 1874.9 589.9 221% 1071.1 73%

spark

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 6.9 5.4 69% 7.6 21% 7.7 22%
2 9.6 11.7 -13% 9.9 -5% 10.3 -15%
3 29.2 28.1 -2% 28.3 -4% 27.4 -2%
4 3.5 3.5 -10% 3.5 -9% 3.6 -10%
5 23.1 23.4 -8% 21.5 -1% 23.3 -10%
7 28.6 29.7 1% 28.5 -10%
8 54.6 51.3 6% 47.4 8%
9 7.9 9.3 -13% 9.3 -13% 9.1 -11%
10 272.8 227.7 4% 230.6 0% 341.3 -9%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 1.8 2.0 -12% 2.0 -12%
1e8 8.8 8.4 24% 9.1 6%
1e9 134.9 119.7 0% 117.8 1%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 48.5 43.3 3% 43.0 -1%
1e1 48.4 45.3 0% 47.0 -3%
2e0 48.7 49.2 -10% 48.0 -5%
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 48.5 43.3 3% 43.0 -1%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 48.5 43.3 3% 43.0 -1%
1 38.9 35.6 -3% 46.3 -11%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 1.6 1.7 -5% 2.1 -27% 1.6 -2%
1 1e8 6.6 2.1 214% 3.0 119% 3.3 100%
1 1e9 12.6 12.6 0% 17.6 -28% 18.1 -30%
2 1e7 1.2 2.0 -40% 1.5 -17% 2.6 -53%
2 1e8 3.9 3.3 21% 3.7 5% 3.5 11%
2 1e9 23.7 29.8 -20% 24.5 -3% 24.9 -4%
3 1e7 1.6 1.8 -9% 1.7 -6% 1.9 -14%
3 1e8 6.1 6.4 -4% 7.0 -11% 6.2 0%
3 1e9 79.9 76.1 4% 76.4 4% 74.1 7%
4 1e7 0.6 0.9 -30% 0.8 -24% 0.8 -19%
4 1e8 1.1 1.2 -7% 1.2 -7% 1.3 -13%
4 1e9 8.8 8.2 6% 8.6 2% 8.6 1%
5 1e7 1.3 1.6 -21% 1.3 -4% 1.7 -24%
5 1e8 4.5 4.7 -3% 5.0 -10% 4.8 -6%
5 1e9 63.6 64.0 0% 58.1 9% 63.3 0%
7 1e7 1.3 1.2 2% 1.6 -19%
7 1e8 5.8 5.5 5% 6.8 -14%
7 1e9 78.9 82.5 -4% 77.1 2%
8 1e7 2.5 2.5 4% 2.5 3%
8 1e8 10.7 9.7 10% 10.2 5%
8 1e9 150.5 141.6 6% 129.6 16%
9 1e7 1.1 1.3 -11% 1.2 -8% 1.3 -16%
9 1e8 2.6 3.0 -13% 3.2 -18% 2.8 -5%
9 1e9 20.0 23.7 -15% 23.4 -14% 23.2 -13%
10 1e7 4.8 4.9 -2% 5.2 -7% 5.0 -2%
10 1e8 37.3 39.5 -5% 41.6 -10% 39.2 -4%
10 1e9 776.2 638.7 21% 645.1 20% 979.8 -20%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 6.9 5.4 69% 7.6 21% 7.7 22%
1 1e1 5.3 7.4 -12% 5.2 -1% 5.1 -3%
1 2e0 5.7 6.6 -24% 5.3 11% 5.3 -2%
2 1e2 9.6 11.7 -13% 9.9 -5% 10.3 -15%
2 1e1 6.7 7.0 2% 7.2 -13% 9.1 -27%
2 2e0 6.2 6.5 -2% 5.8 -5% 5.8 -8%
3 1e2 29.2 28.1 -2% 28.3 -4% 27.4 -2%
3 1e1 36.5 35.6 5% 35.1 3% 38.1 -2%
3 2e0 49.2 51.0 -12% 52.8 -15% 79.8 -19%
4 1e2 3.5 3.5 -10% 3.5 -9% 3.6 -10%
4 1e1 3.1 3.3 1% 3.5 -16% 3.2 0%
4 2e0 3.4 3.4 -3% 3.2 -3% 3.3 -7%
5 1e2 23.1 23.4 -8% 21.5 -1% 23.3 -10%
5 1e1 31.9 27.4 20% 30.6 7% 32.1 6%
5 2e0 42.1 44.0 -11% 44.5 -13% 54.3 -21%
7 1e2 28.6 29.7 1% 28.5 -10%
7 1e1 40.1 37.9 11% 33.5 11%
7 2e0 52.8 56.6 -6% 45.6 1%
8 1e2 54.6 51.3 6% 47.4 8%
8 1e1 52.0 52.4 -1% 47.8 0%
8 2e0 54.7 63.1 -9% 49.7 0%
9 1e2 7.9 9.3 -13% 9.3 -13% 9.1 -11%
9 1e1 5.3 6.8 -24% 6.5 -19% 6.4 -13%
9 2e0 4.9 5.9 -13% 5.4 -13% 6.3 -8%
10 1e2 272.8 227.7 4% 230.6 0% 341.3 -9%
10 1e1 254.6 230.0 3% 253.3 0% 379.0 1%
10 2e0 219.1 205.2 -6% 219.9 -10% 239.8 -11%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 1.8 2.0 -12% 2.0 -12%
1e2 1e8 8.8 8.4 24% 9.1 6%
1e2 1e9 134.9 119.7 0% 117.8 1%
1e1 1e7 2.2 2.1 3% 2.2 -5%
1e1 1e8 9.5 9.3 3% 10.0 -5%
1e1 1e9 133.5 124.5 -4% 128.7 2%
2e0 1e7 1.9 2.3 -13% 2.3 -18%
2e0 1e8 9.7 11.4 -12% 11.5 -2%
2e0 1e9 134.4 133.8 -3% 130.3 4%
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 6.9 5.4 69% 7.6 21% 7.7 22%
1e2 2 9.6 11.7 -13% 9.9 -5% 10.3 -15%
1e2 3 29.2 28.1 -2% 28.3 -4% 27.4 -2%
1e2 4 3.5 3.5 -10% 3.5 -9% 3.6 -10%
1e2 5 23.1 23.4 -8% 21.5 -1% 23.3 -10%
1e2 7 28.6 29.7 1% 28.5 -10%
1e2 8 54.6 51.3 6% 47.4 8%
1e2 9 7.9 9.3 -13% 9.3 -13% 9.1 -11%
1e2 10 272.8 227.7 4% 230.6 0% 341.3 -9%
1e1 1 5.3 7.4 -12% 5.2 -1% 5.1 -3%
1e1 2 6.7 7.0 2% 7.2 -13% 9.1 -27%
1e1 3 36.5 35.6 5% 35.1 3% 38.1 -2%
1e1 4 3.1 3.3 1% 3.5 -16% 3.2 0%
1e1 5 31.9 27.4 20% 30.6 7% 32.1 6%
1e1 7 40.1 37.9 11% 33.5 11%
1e1 8 52.0 52.4 -1% 47.8 0%
1e1 9 5.3 6.8 -24% 6.5 -19% 6.4 -13%
1e1 10 254.6 230.0 3% 253.3 0% 379.0 1%
2e0 1 5.7 6.6 -24% 5.3 11% 5.3 -2%
2e0 2 6.2 6.5 -2% 5.8 -5% 5.8 -8%
2e0 3 49.2 51.0 -12% 52.8 -15% 79.8 -19%
2e0 4 3.4 3.4 -3% 3.2 -3% 3.3 -7%
2e0 5 42.1 44.0 -11% 44.5 -13% 54.3 -21%
2e0 7 52.8 56.6 -6% 45.6 1%
2e0 8 54.7 63.1 -9% 49.7 0%
2e0 9 4.9 5.9 -13% 5.4 -13% 6.3 -8%
2e0 10 219.1 205.2 -6% 219.9 -10% 239.8 -11%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.8 2.0 -12% 2.0 -12%
0 1e8 8.8 8.4 24% 9.1 6%
0 1e9 134.9 119.7 0% 117.8 1%
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 1.8 2.0 -12% 2.0 -12%
0 1e8 8.8 8.4 24% 9.1 6%
0 1e9 134.9 119.7 0% 117.8 1%
1 1e7 1.9 2.0 -6% 2.1 -10%
1 1e8 7.0 8.3 -10% 8.9 -18%
1 1e9 107.7 96.4 5% 128.0 -6%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 234.7 209.4 -3% 267.8 -17%
2 602.1 613.6 -13% 617.4 -15%
3 645.6 596.6 -7% 688.3 -14%
4 617.1 551.7 -6%
5 36.8 45.5 -14% 45.4 -14%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 5.4 5.8 -6% 6.1 -12%
1e8 37.5 50.1 -25% 51.2 -27%
1e9 1539.3 1431.3 8%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 455.1 428.9 -8%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 455.1 428.9 -8%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 4.2 4.2 0% 4.7 -12%
1 1e8 26.2 35.4 -26% 36.9 -28%
1 1e9 673.7 588.6 14% 761.8 -11%
2 1e7 3.5 4.1 -13% 4.2 -16%
2 1e8 32.3 44.6 -27% 45.8 -29%
2 1e9 1770.4 1792.1 -1% 1802.0 -1%
3 1e7 4.4 4.6 -3% 4.8 -8%
3 1e8 34.6 48.1 -28% 49.6 -30%
3 1e9 1897.8 1737.0 9% 2010.5 -5%
4 1e7 4.0 4.3 -6% 5.0 -19%
4 1e8 32.0 43.4 -26% 44.8 -28%
4 1e9 1815.3 1607.4 12%
5 1e7 11.0 12.0 -8% 11.9 -7%
5 1e8 62.6 79.0 -20% 78.9 -20%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 5.4 5.8 -6% 6.1 -12%
0 1e8 37.5 50.1 -25% 51.2 -27%
0 1e9 1539.3 1431.3 8%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 5.4 5.8 -6% 6.1 -12%
0 1e8 37.5 50.1 -25% 51.2 -27%
0 1e9 1539.3 1431.3 8%

cudf

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 0.0 0.1 -66%
2 0.0 0.1 -40%
3 0.1 1.0 -85%
4 0.1 0.3 -52%
5 0.1 0.1 -10%
6 0.5
10 0.5 0.5 3%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 0.2
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 0.2
1e1 0.2
2e0 0.2
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 0.2
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 0.2
1 0.2
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.0 0.1 -66%
2 1e7 0.0 0.1 -40%
3 1e7 0.1 1.0 -85%
4 1e7 0.1 0.3 -52%
5 1e7 0.1 0.1 -10%
6 1e7 0.5
10 1e7 0.5 0.5 3%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 0.0 0.1 -66%
1 1e1 0.0 0.0 -20%
1 2e0 0.0 0.0 -8%
2 1e2 0.0 0.1 -40%
2 1e1 0.0 0.0 17%
2 2e0 0.0 0.0 19%
3 1e2 0.1 1.0 -85%
3 1e1 0.2 0.1 44%
3 2e0 0.2 0.2 -1%
4 1e2 0.1 0.3 -52%
4 1e1 0.1 0.0 112%
4 2e0 0.1 0.1 55%
5 1e2 0.1 0.1 -10%
5 1e1 0.1 0.1 -8%
5 2e0 0.1 0.1 -6%
6 1e2 0.5
6 1e1 0.4
6 2e0 0.3
10 1e2 0.5 0.5 3%
10 1e1 0.6 0.6 3%
10 2e0 0.6 0.7 -3%
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 0.2
1e1 1e7 0.2
2e0 1e7 0.2
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 0.0 0.1 -66%
1e2 2 0.0 0.1 -40%
1e2 3 0.1 1.0 -85%
1e2 4 0.1 0.3 -52%
1e2 5 0.1 0.1 -10%
1e2 6 0.5
1e2 10 0.5 0.5 3%
1e1 1 0.0 0.0 -20%
1e1 2 0.0 0.0 17%
1e1 3 0.2 0.1 44%
1e1 4 0.1 0.0 112%
1e1 5 0.1 0.1 -8%
1e1 6 0.4
1e1 10 0.6 0.6 3%
2e0 1 0.0 0.0 -8%
2e0 2 0.0 0.0 19%
2e0 3 0.2 0.2 -1%
2e0 4 0.1 0.1 55%
2e0 5 0.1 0.1 -6%
2e0 6 0.3
2e0 10 0.6 0.7 -3%
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.2
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.2
1 1e7 0.2

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 0.1 0.0 103%
2 0.0 0.0 -2%
3 0.0 0.0 0%
4 0.0 0.0 0%
5 0.2 0.2 1%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 0.1 0.1 20%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 0.1 0.1 20%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 0.1 0.1 20%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.1 0.0 103%
2 1e7 0.0 0.0 -2%
3 1e7 0.0 0.0 0%
4 1e7 0.0 0.0 0%
5 1e7 0.2 0.2 1%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.1 0.1 20%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.1 0.1 20%

dask

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 352.6
2 0.8 0.9 -14% 0.8 0% 0.8 100%
3 25.6 26.1 2% 26.4 2% 71.6 -20%
4 0.9 0.8 11% 0.9 8% 1.0 99%
5 4.9 5.2 -9% 5.1 -2% 4.3 124%
7 22.7 23.3 -4% 22.2 -1%
8 212.4 251.6 -8% 220.5 -2%
10 259.0
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 6.2 6.2 0% 6.2 0%
1e8
1e9 1049.4
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2
1e1
2e0
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0
1
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.2 0.2 -6% 0.3 -34% 0.1 78%
1 1e8 8.2 7.9 4% 7.9 4% 0.6 1240%
1 1e9 1049.4
2 1e7 0.6 0.6 -5% 0.6 8% 0.2 238%
2 1e8 0.9 1.2 -23% 1.0 -8% 1.5 -36%
3 1e7 1.7 1.6 6% 1.6 7% 1.4 24%
3 1e8 49.4 50.7 -2% 51.3 -3% 141.8 -65%
4 1e7 0.7 0.5 25% 0.5 28% 0.2 242%
4 1e8 1.1 1.1 -2% 1.2 -11% 1.9 -42%
5 1e7 1.0 1.2 -15% 1.0 0% 0.3 243%
5 1e8 8.8 9.2 -4% 9.3 -4% 8.3 6%
7 1e7 1.5 1.6 -5% 1.6 -5%
7 1e8 44.0 45.0 -2% 42.7 2%
8 1e7 24.1 24.4 -1% 24.3 0%
8 1e8 400.6 478.8 -16% 416.8 -3%
10 1e7 20.0 19.7 1% 19.4 2% 14.5 38%
10 1e8 503.6
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 352.6
1 1e1 5.4 5.4 -8% 4.8 5% 0.3 907%
1 2e0 5.7 5.9 -8% 5.9 -9% 0.3 922%
2 1e2 0.8 0.9 -14% 0.8 0% 0.8 100%
2 1e1 0.5 0.6 -3% 0.5 4% 0.6 83%
2 2e0 0.5 0.6 -7% 0.6 -8% 0.6 74%
3 1e2 25.6 26.1 2% 26.4 2% 71.6 -20%
3 1e1 169.4 176.7 -3% 175.8 0% 239.8 -6%
3 2e0 395.6
4 1e2 0.9 0.8 11% 0.9 8% 1.0 99%
4 1e1 2.5 2.8 -8% 3.4 -20% 1.0 170%
4 2e0 1.1
5 1e2 4.9 5.2 -9% 5.1 -2% 4.3 124%
5 1e1 20.2 21.1 -1% 19.7 0% 15.2 69%
5 2e0 35.8
7 1e2 22.7 23.3 -4% 22.2 -1%
7 1e1 146.6 149.0 0% 170.5 -16%
7 2e0 36.2 36.8 -1% 36.1 0%
8 1e2 212.4 251.6 -8% 220.5 -2%
8 1e1 2249.9 2456.2 -4% 2270.7 0%
8 2e0 1028.6 1034.6 0% 1030.0 0%
10 1e2 259.0
10 1e1 438.8
10 2e0 621.7
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 6.2 6.2 0% 6.2 0%
1e2 1e8
1e2 1e9 1049.4
1e1 1e7 33.8 34.1 -3% 34.4 -3%
1e1 1e8
2e0 1e7 145.7 146.4 -1% 145.7 0%
2e0 1e8 339.9
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 352.6
1e2 2 0.8 0.9 -14% 0.8 0% 0.8 100%
1e2 3 25.6 26.1 2% 26.4 2% 71.6 -20%
1e2 4 0.9 0.8 11% 0.9 8% 1.0 99%
1e2 5 4.9 5.2 -9% 5.1 -2% 4.3 124%
1e2 7 22.7 23.3 -4% 22.2 -1%
1e2 8 212.4 251.6 -8% 220.5 -2%
1e2 10 259.0
1e1 1 5.4 5.4 -8% 4.8 5% 0.3 907%
1e1 2 0.5 0.6 -3% 0.5 4% 0.6 83%
1e1 3 169.4 176.7 -3% 175.8 0% 239.8 -6%
1e1 4 2.5 2.8 -8% 3.4 -20% 1.0 170%
1e1 5 20.2 21.1 -1% 19.7 0% 15.2 69%
1e1 7 146.6 149.0 0% 170.5 -16%
1e1 8 2249.9 2456.2 -4% 2270.7 0%
1e1 10 438.8
2e0 1 5.7 5.9 -8% 5.9 -9% 0.3 922%
2e0 2 0.5 0.6 -7% 0.6 -8% 0.6 74%
2e0 3 395.6
2e0 4 1.1
2e0 5 35.8
2e0 7 36.2 36.8 -1% 36.1 0%
2e0 8 1028.6 1034.6 0% 1030.0 0%
2e0 10 621.7
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 6.2 6.2 0% 6.2 0%
0 1e8
0 1e9 1049.4
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 6.2 6.2 0% 6.2 0%
0 1e8
0 1e9 1049.4
1 1e7 6.0 6.0 8% 6.0 11%
1 1e8
1 1e9 970.0 1230.6 -21%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 117.1 103.8 8% 102.6 9%
2 132.6 114.6 7% 112.6 9%
3 127.9 117.4 2% 122.0 0%
4 147.1 145.9 -1% 141.8 -1%
5 208.3 205.8 1% 211.8 -1%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 55.1 54.9 -1% 56.2 -2%
1e8 245.6 223.6 10% 222.1 11%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 139.7 129.9 3% 130.0 3%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 139.7 129.9 3% 130.0 3%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 15.7 15.3 2% 15.2 3%
1 1e8 218.5 192.2 13% 189.9 15%
2 1e7 17.0 17.4 -2% 17.2 -1%
2 1e8 248.2 211.8 17% 208.0 19%
3 1e7 15.2 15.9 -4% 16.0 -5%
3 1e8 240.6 218.9 9% 228.0 5%
4 1e7 19.2 20.2 -4% 20.9 -8%
4 1e8 275.0 271.7 1% 262.7 4%
5 1e7 208.3 205.8 1% 211.8 -1%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 55.1 54.9 -1% 56.2 -2%
0 1e8 245.6 223.6 10% 222.1 11%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 55.1 54.9 -1% 56.2 -2%
0 1e8 245.6 223.6 10% 222.1 11%

juliadf

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 11.6 12.0 0% 14.3 -13%
2 6.0 5.2 9% 4.1 20%
3 62.4 57.5 3% 58.6 0%
4 14.2 12.2 10% 14.0 5%
5 76.1 70.6 1% 77.7 -5%
6 64.1 70.2 -1% 72.2 -2%
7 152.6 149.0 0% 142.6 3%
8 144.3 151.8 -2% 153.3 -2%
9 98.2 82.4 8% 82.3 9%
10 252.2 243.7 1% 254.9 -2%
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 2.0 1.9 2% 1.9 2%
1e8 13.1 13.2 1% 13.9 -3%
1e9 249.4 241.3 5% 246.4 4%
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 88.2 85.5 3% 87.4 1%
1e1 11.3 11.3 -2% 11.6 0%
2e0
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 88.2 85.5 3% 87.4 1%
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 88.2 85.5 3% 87.4 1%
1 73.4 74.6 0% 80.4 -1%
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 6.6 6.3 5% 7.0 -5% 4.8 37%
1 1e8 7.4 7.5 -1% 8.3 -10% 6.2 19%
1 1e9 20.8 22.2 -6% 27.6 -24%
2 1e7 0.3 0.3 1% 0.3 5% 0.6 -44%
2 1e8 1.4 1.2 10% 1.3 6% 4.8 -70%
2 1e9 16.2 14.0 15% 10.8 50%
3 1e7 1.0 1.0 1% 1.1 -3% 1.1 -10%
3 1e8 4.9 4.9 0% 5.0 -2% 14.8 -66%
3 1e9 181.3 166.7 8% 169.8 6%
4 1e7 0.7 0.6 9% 0.6 13% 0.7 0%
4 1e8 3.0 2.9 5% 3.0 2% 3.8 -21%
4 1e9 38.8 33.2 16% 38.3 1%
5 1e7 0.7 0.7 -5% 0.7 -7% 1.1 -40%
5 1e8 8.9 8.8 1% 9.6 -7% 19.0 -53%
5 1e9 218.8 202.4 8% 222.8 -1%
6 1e7 2.6 2.5 3% 2.5 6%
6 1e8 15.6 15.3 1% 15.8 -1%
6 1e9 174.1 192.7 -9% 198.2 -12%
7 1e7 1.6 1.6 0% 1.5 3%
7 1e8 16.9 17.1 0% 17.3 -1%
7 1e9 439.3 428.4 2% 409.1 7%
8 1e7 1.9 1.9 0% 1.9 1%
8 1e8 23.8 24.0 0% 24.6 -3%
8 1e9 407.1 429.6 -5% 433.5 -6%
9 1e7 1.8 1.8 4% 1.7 6% 2.1 -10%
9 1e8 15.9 15.9 0% 15.9 0% 16.1 -1%
9 1e9 276.9 229.5 20% 229.4 20%
10 1e7 2.3 2.3 2% 2.2 5% 3.2 -26%
10 1e8 33.5 34.2 -2% 38.2 -12% 34.0 -1%
10 1e9 720.8 694.6 3% 724.2 0%
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 11.6 12.0 0% 14.3 -13%
1 1e1 7.6 7.7 -1% 8.2 -6% 5.8 32%
1 2e0 7.5
2 1e2 6.0 5.2 9% 4.1 20%
2 1e1 0.7 0.8 -10% 0.7 -2% 1.2 -28%
2 2e0 1.1
3 1e2 62.4 57.5 3% 58.6 0%
3 1e1 9.9 9.8 0% 10.1 -1% 17.7 -39%
3 2e0 24.8
4 1e2 14.2 12.2 10% 14.0 5%
4 1e1 1.9 1.8 0% 1.9 7% 2.3 -13%
4 2e0 2.5
5 1e2 76.1 70.6 1% 77.7 -5%
5 1e1 8.2 8.1 -1% 8.5 -6% 16.4 -51%
5 2e0 21.1
6 1e2 64.1 70.2 -1% 72.2 -2%
6 1e1 6.6 6.9 -5% 6.5 3%
6 2e0 2.0 2.0 0% 1.9 4%
7 1e2 152.6 149.0 0% 142.6 3%
7 1e1 18.5 18.5 -1% 18.9 -2%
7 2e0 4.1 4.2 -1% 4.2 -1%
8 1e2 144.3 151.8 -2% 153.3 -2%
8 1e1 29.8 29.5 0% 31.6 -5%
8 2e0 9.6 9.5 1% 9.9 -3%
9 1e2 98.2 82.4 8% 82.3 9%
9 1e1 6.3 6.3 -2% 6.2 4% 6.2 -9%
9 2e0 6.7
10 1e2 252.2 243.7 1% 254.9 -2%
10 1e1 23.8 23.7 -2% 23.4 1% 25.2 -14%
10 2e0 34.5
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 2.0 1.9 2% 1.9 2%
1e2 1e8 13.1 13.2 1% 13.9 -3%
1e2 1e9 249.4 241.3 5% 246.4 4%
1e1 1e7 2.3 2.4 -4% 2.3 1%
1e1 1e8 20.3 20.2 0% 20.9 -2%
2e0 1e7 3.1 3.1 1% 3.2 1%
2e0 1e8 25.0
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 11.6 12.0 0% 14.3 -13%
1e2 2 6.0 5.2 9% 4.1 20%
1e2 3 62.4 57.5 3% 58.6 0%
1e2 4 14.2 12.2 10% 14.0 5%
1e2 5 76.1 70.6 1% 77.7 -5%
1e2 6 64.1 70.2 -1% 72.2 -2%
1e2 7 152.6 149.0 0% 142.6 3%
1e2 8 144.3 151.8 -2% 153.3 -2%
1e2 9 98.2 82.4 8% 82.3 9%
1e2 10 252.2 243.7 1% 254.9 -2%
1e1 1 7.6 7.7 -1% 8.2 -6% 5.8 32%
1e1 2 0.7 0.8 -10% 0.7 -2% 1.2 -28%
1e1 3 9.9 9.8 0% 10.1 -1% 17.7 -39%
1e1 4 1.9 1.8 0% 1.9 7% 2.3 -13%
1e1 5 8.2 8.1 -1% 8.5 -6% 16.4 -51%
1e1 6 6.6 6.9 -5% 6.5 3%
1e1 7 18.5 18.5 -1% 18.9 -2%
1e1 8 29.8 29.5 0% 31.6 -5%
1e1 9 6.3 6.3 -2% 6.2 4% 6.2 -9%
1e1 10 23.8 23.7 -2% 23.4 1% 25.2 -14%
2e0 1 7.5
2e0 2 1.1
2e0 3 24.8
2e0 4 2.5
2e0 5 21.1
2e0 6 2.0 2.0 0% 1.9 4%
2e0 7 4.1 4.2 -1% 4.2 -1%
2e0 8 9.6 9.5 1% 9.9 -3%
2e0 9 6.7
2e0 10 34.5
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.0 1.9 2% 1.9 2%
0 1e8 13.1 13.2 1% 13.9 -3%
0 1e9 249.4 241.3 5% 246.4 4%
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 2.0 1.9 2% 1.9 2%
0 1e8 13.1 13.2 1% 13.9 -3%
0 1e9 249.4 241.3 5% 246.4 4%
1 1e7 1.9 1.9 2% 2.0 0%
1 1e8 12.1 12.7 -3% 12.6 -2%
1 1e9 206.2 209.3 0% 226.5 -3%

join

Overview
by Question (no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 231.3 232.0 -3% 230.3 -1%
2 257.8 258.4 -3% 253.1 5%
3 305.9 307.1 -3% 284.7 6%
4 263.5 265.8 -4% 259.4 5%
5 461.5 464.0 -1% 457.1 1%
by Size (no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 16.5 17.5 -6% 15.8 4%
1e8 591.6 593.4 0% 578.0 2%
by NA fraction (unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 304.0 305.4 -3% 296.9 3%
by Sortedness (no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 304.0 305.4 -3% 296.9 3%
Question
by Question Size (no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 14.1 15.0 -5% 14.5 -2%
1 1e8 448.5 449.0 0% 446.2 0%
2 1e7 12.2 13.2 -7% 11.2 8%
2 1e8 503.4 503.7 0% 494.9 1%
3 1e7 17.2 18.5 -6% 16.2 6%
3 1e8 594.6 595.6 0% 553.2 7%
4 1e7 12.5 13.6 -8% 11.4 9%
4 1e8 514.5 518.1 0% 507.4 1%
5 1e7 26.4 27.3 -3% 25.7 2%
5 1e8 896.7 900.7 0% 888.4 0%
NA fraction
by NA fraction Size (unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 16.5 17.5 -6% 15.8 4%
0 1e8 591.6 593.4 0% 578.0 2%
Sortedness
by Sortedness Size (no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 16.5 17.5 -6% 15.8 4%
0 1e8 591.6 593.4 0% 578.0 2%

clickhouse

groupby

Overview
by Question (k=1e2, no NA, unsorted)
Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 8.1 36.9 276% 85.1 250% 15.4 186%
2 4.5 4.5 51% 3.4 58% 7.4 38%
3 23.1 14.4 29% 7.2 72% 33.4 -22%
4 11.6 11.0 41% 17.2 33% 20.2 11%
5 6.3 5.6 15% 10.9 -3% 13.6 -21%
6 7.7 7.8 6% 15.6 -29%
7 5.6 5.9 5% 19.0 -39%
8 45.0 35.5 10% 44.4 -2%
9 34.8 34.2 39% 37.0 38%
10 503.2
by Size (k=1e2, no NA, unsorted)
Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e7 0.5 0.3 25% 0.4 -1%
1e8 4.1 2.6 133% 3.1 126%
1e9 190.5
by K cardinality (no NA, unsorted)
K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 65.0
1e1 90.8
2e0 99.4
by NA fraction (k=1e2, unsorted)
NA fraction Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 65.0
by Sortedness (k=1e2, no NA)
Sorted Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 65.0
1 56.1
Question
by Question Size (k=1e2, no NA, unsorted)
Q Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e7 0.1 0.1 2% 0.1 -42% 0.1 10%
1 1e8 2.8 0.3 906% 0.3 884% 0.4 600%
1 1e9 21.5 110.4 -80% 254.9 -91% 45.8 -52%
2 1e7 0.2 0.1 7% 0.1 15% 0.1 21%
2 1e8 2.2 0.9 157% 0.9 136% 0.9 140%
2 1e9 11.0 12.5 -11% 9.0 22% 21.1 -47%
3 1e7 0.2 0.1 20% 0.2 -25% 0.2 -2%
3 1e8 1.2 1.2 4% 1.1 8% 1.8 -34%
3 1e9 68.0 42.0 62% 20.3 234% 98.1 -30%
4 1e7 0.1 0.0 87% 0.0 97% 0.0 67%
4 1e8 0.4 0.3 32% 0.3 36% 0.3 10%
4 1e9 34.3 32.6 5% 51.2 -32% 60.2 -43%
5 1e7 0.1 0.1 26% 0.1 24% 0.1 15%
5 1e8 1.1 1.1 6% 1.1 8% 1.5 -25%
5 1e9 17.7 15.6 13% 31.7 -43% 39.2 -54%
6 1e7 0.2 0.2 10% 0.5 -51%
6 1e8 1.2 1.1 12% 1.1 14%
6 1e9 21.6 22.1 -2% 45.4 -52%
7 1e7 0.2 0.2 24% 0.4 -52%
7 1e8 1.2 1.2 -3% 1.1 5%
7 1e9 15.3 16.3 -5% 55.5 -72%
8 1e7 0.8 0.8 3% 0.9 -12%
8 1e8 7.1 7.2 -1% 6.9 2%
8 1e9 127.2 98.6 28% 125.4 1%
9 1e7 0.2 0.3 -29% 0.2 -21%
9 1e8 2.5 1.0 148% 1.0 143%
9 1e9 101.8 101.2 0% 109.8 -7%
10 1e7 2.6 1.3 102% 1.7 49%
10 1e8 21.0 11.9 75% 16.9 24%
10 1e9 1486.1
by Question K cardinality (no NA, unsorted)
Q K Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1 1e2 8.1 36.9 276% 85.1 250% 15.4 186%
1 1e1 27.8 13.6 78% 14.9 70% 40.7 15%
1 2e0 15.3 1.1 604% 10.5 188%
2 1e2 4.5 4.5 51% 3.4 58% 7.4 38%
2 1e1 12.4 7.0 59% 9.1 105% 7.1 34%
2 2e0 6.1 4.3 30% 4.3 118%
3 1e2 23.1 14.4 29% 7.2 72% 33.4 -22%
3 1e1 143.3 53.0 78% 83.0 42% 47.2 73%
3 2e0 162.9 51.4 80% 69.3 30%
4 1e2 11.6 11.0 41% 17.2 33% 20.2 11%
4 1e1 12.5 24.0 20% 24.5 16% 18.6 3%
4 2e0 11.7 29.7 41% 23.1 46%
5 1e2 6.3 5.6 15% 10.9 -3% 13.6 -21%
5 1e1 46.8 14.6 135% 15.6 133% 19.3 100%
5 2e0 82.3 22.7 90% 21.9 87%
6 1e2 7.7 7.8 6% 15.6 -29%
6 1e1 7.8 14.7 1% 14.4 24%
6 2e0 11.6 16.5 -4% 5.7 74%
7 1e2 5.6 5.9 5% 19.0 -39%
7 1e1 80.3 26.0 77% 25.9 85%
7 2e0 136.3 33.9 109% 34.4 96%
8 1e2 45.0 35.5 10% 44.4 -2%
8 1e1 90.7 31.3 77%
8 2e0 123.5 33.3 107%
9 1e2 34.8 34.2 39% 37.0 38%
9 1e1 13.6 25.2 20%
9 2e0 8.7 18.5 50%
10 1e2 503.2
10 1e1 473.2
10 2e0 435.3
K cardinality
by K cardinality Size (no NA, unsorted)
K Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1e7 0.5 0.3 25% 0.4 -1%
1e2 1e8 4.1 2.6 133% 3.1 126%
1e2 1e9 190.5
1e1 1e7 0.4 0.3 56% 0.3 81%
1e1 1e8 4.0 2.8 34% 3.2 29%
1e1 1e9 268.1
2e0 1e7 0.5 0.4 34% 0.4 62%
2e0 1e8 4.5 3.4 47% 4.2 70%
2e0 1e9 293.2
by K cardinality Question (no NA, unsorted)
K Q Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
1e2 1 8.1 36.9 276% 85.1 250% 15.4 186%
1e2 2 4.5 4.5 51% 3.4 58% 7.4 38%
1e2 3 23.1 14.4 29% 7.2 72% 33.4 -22%
1e2 4 11.6 11.0 41% 17.2 33% 20.2 11%
1e2 5 6.3 5.6 15% 10.9 -3% 13.6 -21%
1e2 6 7.7 7.8 6% 15.6 -29%
1e2 7 5.6 5.9 5% 19.0 -39%
1e2 8 45.0 35.5 10% 44.4 -2%
1e2 9 34.8 34.2 39% 37.0 38%
1e2 10 503.2
1e1 1 27.8 13.6 78% 14.9 70% 40.7 15%
1e1 2 12.4 7.0 59% 9.1 105% 7.1 34%
1e1 3 143.3 53.0 78% 83.0 42% 47.2 73%
1e1 4 12.5 24.0 20% 24.5 16% 18.6 3%
1e1 5 46.8 14.6 135% 15.6 133% 19.3 100%
1e1 6 7.8 14.7 1% 14.4 24%
1e1 7 80.3 26.0 77% 25.9 85%
1e1 8 90.7 31.3 77%
1e1 9 13.6 25.2 20%
1e1 10 473.2
2e0 1 15.3 1.1 604% 10.5 188%
2e0 2 6.1 4.3 30% 4.3 118%
2e0 3 162.9 51.4 80% 69.3 30%
2e0 4 11.7 29.7 41% 23.1 46%
2e0 5 82.3 22.7 90% 21.9 87%
2e0 6 11.6 16.5 -4% 5.7 74%
2e0 7 136.3 33.9 109% 34.4 96%
2e0 8 123.5 33.3 107%
2e0 9 8.7 18.5 50%
2e0 10 435.3
NA fraction
by NA fraction Size (k=1e2, unsorted)
NA fraction Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.5 0.3 25% 0.4 -1%
0 1e8 4.1 2.6 133% 3.1 126%
0 1e9 190.5
Sortedness
by Sortedness Size (k=1e2, no NA)
Sorted Size Now LastRun LR ∆ LastWeek LW ∆ LastMonth LM ∆ LastYear LY ∆
0 1e7 0.5 0.3 25% 0.4 -1%
0 1e8 4.1 2.6 133% 3.1 126%
0 1e9 190.5
1 1e7 0.4 0.3 38% 0.3 49%
1 1e8 4.0 2.5 162% 2.9 196%
1 1e9 163.9

join

join for clickhouse not yet implemented.

Details

Environment

Nodename: mr-dl11

Timings


Report was generated on: 2020-09-09 01:56:15 PDT.